Using membership with Oracle database in ASP.NET MVC 3

Before you do it you need setup and configure Oracle Providers for ASP.NET. You can do this follow by link: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10767/installation.htm#BEGIN

After installation and configuration are success, we will do following:

1. Create a new ASP.NET MVC 3 project

The default App uses an AspNetSqlMembershipProvider when we create a new project. We can see them in Web.config file.

2. Edit the Web.config by follow code:

Edit connection string

<connectionStrings>
	<add name="OraAspNetConnectionString" connectionString="data source=XE; User Id= ASPNET_DB_USER; Password= ****;"
		providerName="Oracle.DataAccess.Client" />
</connectionStrings>

Next edit membership in <system.web/>

<membership defaultProvider="OracleMembershipProvider">
  <providers>
	<clear/>
	<add name="OracleMembershipProvider" type="Oracle.Web.Security.OracleMembershipProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342"
		 connectionStringName="OraAspNetConnectionString" applicationName="" enablePasswordRetrieval="false"
		 enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false"
		 passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7"
		 minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""  />
  </providers>
</membership>

<profile>
  <providers>
	<clear/>
	<add name="OracleProfileProvider" type="Oracle.Web.Profile.OracleProfileProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342"
		 connectionStringName="OraAspNetConnectionString" applicationName="/"/>
  </providers>
</profile>

<roleManager enabled="false">
  <providers>
	<clear/>
	<add name="OracleRoleProvider" type="Oracle.Web.Security.OracleRoleProvider, Oracle.Web, Version=2.111.6.20, Culture=neutral, PublicKeyToken=89b483f429c47342"
		 connectionStringName="OraAspNetConnectionString" applicationName="/" />
	<add name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider" applicationName="/" />
  </providers>
</roleManager>

3. Build and Run website

4. Click “Logon” on website

5. Click “Register” to Register user.

6. Check in Oracle database